{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Invoice","Change Order","Analyze","Sheet4","Help"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Invoice","index":0,"n_rows":51,"n_cols":9,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["QTY","ITEM #","DESCRIPTION",null,null,null,"PRICE","$ IN BID","DIFFERENCE"]
[]
[null,null,"KITCHEN"]
[1,"FRGX160","30 X 19 STAINLESS STEEL UC SINK",null,null,null,512.04,450,{"$f":"G4-H4","v":62.039999999999964}]
[1,"K10430BN","KOHLER REM LEVER BRUSHED NICKLE FAUCET",null,null,null,283.16000000000003,254,29.160000000000025]
[1,"PROCOM","3/4 HP PRO COMP DISPOSAL",null,null,null,224.79,80,144.79]
[1,"ISTCSN","SINK TOP SWITCH SN",null,null,null,28.89,0,28.89]
[1,"ISTSOO","SINK TOP AIR SWITCH & TRIM KIT",null,null,null,78.09,0,78.09]
[1,"PF1432SS","STAINLESS STEEL BASKET STRAINER",null,null,null,9,0,9]
[]
[null,null,"MASTER BATH"]
[1,"K4198-0","WELLWORTH WHITE ELONGATED GPF BOWL",null,null,null,224.85,166,{"$f":"G12-H12","v":58.849999999999994}]
[1,"K4468-0","WELLWORTH WHITE GPF TANK",null,null,null,195,210,{"$f":"H13-G13","v":15}]
[1,"PFTSSC200","WHITE ELONGATED PLASTIC SEAT",null,null,null,85,92,{"$f":"H14-G14","v":7}]
[1,"CSIY5401B","KINGSLEY BRUSHED NICKLE TANK LEVER",null,null,null,31.19,0,{"$f":"G15-H15","v":31.19}]
[2,"MIR1714W"," 1 X 14 UC WHITE LAVES",null,null,null,111.56,120,-8.4399999999999977]
[2,"D3551SS","2 HANDLE FAUCETS",null,null,null,606.62,422,184.62]
[1,"DRI0000PX","MONITOR ROUGH IN VALVE",null,null,null,35.4,45.46,-10.060000000000002]
[1,"DT1425SS","1400 SHOWER TRIM",null,null,null,178.47,161,17.47]
[1,"PFW7040","*1109 WHITE ACRYLIC OVAL TUB",null,null,null,1058.99,739,319.99]
[1,"DT2751SS","3 HANDLE ROMAN TUB FAUCET",null,null,null,303.27,175,128.26999999999998]
[1,"DR2707","RT ROUGH IN KIT",null,null,null,78.89,75,3.8900000000000006]
[1,"W601PP","ABS BRUSHED NICKLE PIPE",null,null,null,44.93,0,44.93]
[1,"MB132999","BRUSHED NICKLE GRID DRAIN",null,null,null,20.329999999999998,0,20.329999999999998]
[]
[null,null,"POWDER BATH"]
[1,"K4198-0","WELLWORTH WHITE ELONGATED GPF BOWL",null,null,null,224.85,166,{"$f":"G27-H27","v":58.849999999999994}]
[1,"K4468-0","WELLWORTH WHITE GPF TANK"]
[1,"PFTSSC200","WHITE ELONGATED PLASTIC SEAT"]
[1,"CSIY5401B","KINGSLEY BRUSHED NICKLE TANK LEVER",null,null,null,31.19,0,{"$f":"G30-H30","v":31.19}]
[1,"MIR1714W","17 X 14 WHITE LAVE",null,null,null,55.78,60,{"$f":"G31-H31","v":-4.2199999999999989}]
[1,"D551SSD"," 1 HANDLE LAVE FAUCET",null,null,null,228.06,211,{"$f":"G32-H32","v":17.060000000000002}]
[]
[null,null,"GUEST BATH"]
[1,"K4198-0","WELLWORTH WHITE ELONGATED GPF BOWL",null,null,null,224.85,166,{"$f":"G35-H35","v":58.849999999999994}]
[1,"K4468-0","WELLWORTH WHITE GPF TANK"]
[1,"PFTSSC200","WHITE ELONGATED PLASTIC SEAT"]
[1,"CSIY5401B","KINGSLEY BRUSHED NICKLE TANK LEVER",null,null,null,31.19,0,{"$f":"G38-H38","v":31.19}]
[1,"MIR1714W","17 X 14 WHITE LAVE",null,null,null,55.78,60,-4.2199999999999989]
[1,"D3551SS","2 HANDLE WIDESPREAD LAVE FAUCET",null,null,null,303.31,211,92.31]
[1,"DRI0000PX","MONITOR ROUGH IN VALVE",null,null,null,35.4,45.46,-10.060000000000002]
[1,"DT1425SS","1400 SHOWER TRIM",null,null,null,178.47,161,17.47]
[1,"MBI32999","BRUSHED NICKLE GRID DRAIN",null,null,null,20.329999999999998,0,20.329999999999998]
[3,"DRP10612","THICK TILE MOUNTING KIT",null,null,null,52.29,0,52.29]
[2,"MB132935","BRUSHED NICKLE SNAPIN GRID SHOWER DRAIN",null,null,null,41.58,0,41.58]
[1,null,"WHITE GARAGE SINK",null,null,null,375,0,375]
[1,"ENSC40","40K TANK WATER SOFTENER",null,null,null,631.34,0,631.34]
[1,null,"LABOR & INSTALATION FOR SOFTENER",null,null,null,100,0,100]
[1,"TK3LP","PROPANE TANKLESS WATER HEATER",null,null,null,1265,0,1265]
[]
[null,"TOTALS",null,null,null,null,{"$f":"SUM(G4:G49)","v":7964.89},{"$f":"SUM(H4:H49)","v":4069.92},{"$f":"SUM(I4:I49)","v":3938.97}]

{"sheet":"Change Order","index":1,"n_rows":1,"n_cols":9,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["QTY","ITEM #","DESCRIPTION",null,null,null,"PRICE","$ IN BID","DIFFER IN PRICE"]

{"sheet":"Analyze","index":2,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["QTY","ITEM #","DESCRIPTION",null,null,null,"PRICE","$ IN BID","DIFFER IN PRICE","%"]
[]
[1,"PFW7040","*1109 WHITE ACRYLIC OVAL TUB",null,null,null,1058.99,739,319.99,0.6978347293175573]
[2,"D3551SS","2 HANDLE FAUCETS",null,null,null,606.62,422,184.62,0.69565790775114567]
[1,"PROCOM","3/4 HP PRO COMP DISPOSAL",null,null,null,224.79,80,144.79,0.35588771742515235]
[1,"DT2751SS","3 HANDLE ROMAN TUB FAUCET",null,null,null,303.27,175,128.27000000000001,0.57704355854519074]
[1,"D3551SS","2 HANDLE WIDESPREAD LAVE FAUCET",null,null,null,303.31,211,92.31,0.69565790775114567]
[1,"FRGX160","30 X 19 STAINLESS STEEL UC SINK",null,null,null,512.04,450,62.04,0.87883759081321777]
[1,"K4198-0","WELLWORTH WHITE ELONGATED GPF BOWL",null,null,null,224.85,166,58.85,0.73826995774961091]
[1,"K4198-0","WELLWORTH WHITE ELONGATED GPF BOWL",null,null,null,224.85,166,58.85,0.73826995774961091]
[1,"K4198-0","WELLWORTH WHITE ELONGATED GPF BOWL",null,null,null,224.85,166,58.85,0.73826995774961091]
[1,"K10430BN","KOHLER REM LEVER BRUSHED NICKLE FAUCET",null,null,null,283.16000000000003,254,29.16,0.89701935301596258]
[null,"TOTALS",null,null,null,null,3966.73,2829,1137.73,0.71318189037317892]

{"sheet":"Sheet4","index":3,"n_rows":50,"n_cols":10,"rows_kept":50,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,"KITCHEN"]
[1,1,"FRGX160","30 X 19 STAINLESS STEEL UC SINK",null,null,null,512.04,450,{"$f":"H3-I3","v":62.039999999999964}]
[1,1,"K10430BN","KOHLER REM LEVER BRUSHED NICKLE FAUCET",null,null,null,283.16000000000003,254,29.160000000000025]
[1,1,"PROCOM","3/4 HP PRO COMP DISPOSAL",null,null,null,224.79,80,144.79]
[1,1,"ISTCSN","SINK TOP SWITCH SN",null,null,null,28.89,0,28.89]
[1,1,"ISTSOO","SINK TOP AIR SWITCH & TRIM KIT",null,null,null,78.09,0,78.09]
[1,1,"PF1432SS","STAINLESS STEEL BASKET STRAINER",null,null,null,9,0,9]
[]
[null,null,null,"MASTER BATH"]
[1,1,"K4198-0","WELLWORTH WHITE ELONGATED GPF BOWL",null,null,null,224.85,166,{"$f":"H11-I11","v":58.849999999999994}]
[1,1,"K4468-0","WELLWORTH WHITE GPF TANK",null,null,null,195,210,{"$f":"I12-H12","v":15}]
[1,1,"PFTSSC200","WHITE ELONGATED PLASTIC SEAT",null,null,null,85,92,{"$f":"I13-H13","v":7}]
[1,1,"CSIY5401B","KINGSLEY BRUSHED NICKLE TANK LEVER",null,null,null,31.19,0,{"$f":"H14-I14","v":31.19}]
[2,2,"MIR1714W"," 1 X 14 UC WHITE LAVES",null,null,null,111.56,120,-8.4399999999999977]
[2,2,"D3551SS","2 HANDLE FAUCETS",null,null,null,606.62,422,184.62]
[1,1,"DRI0000PX","MONITOR ROUGH IN VALVE",null,null,null,35.4,45.46,-10.060000000000002]
[1,1,"DT1425SS","1400 SHOWER TRIM",null,null,null,178.47,161,17.47]
[1,1,"PFW7040","*1109 WHITE ACRYLIC OVAL TUB",null,null,null,1058.99,739,319.99]
[1,1,"DT2751SS","3 HANDLE ROMAN TUB FAUCET",null,null,null,303.27,175,128.26999999999998]
[1,1,"DR2707","RT ROUGH IN KIT",null,null,null,78.89,75,3.8900000000000006]
[1,1,"W601PP","ABS BRUSHED NICKLE PIPE",null,null,null,44.93,0,44.93]
[1,1,"MB132999","BRUSHED NICKLE GRID DRAIN",null,null,null,20.329999999999998,0,20.329999999999998]
[]
[null,null,null,"POWDER BATH"]
[1,1,"K4198-0","WELLWORTH WHITE ELONGATED GPF BOWL",null,null,null,224.85,166,{"$f":"H26-I26","v":58.849999999999994}]
[1,1,"K4468-0","WELLWORTH WHITE GPF TANK"]
[1,1,"PFTSSC200","WHITE ELONGATED PLASTIC SEAT"]
[1,1,"CSIY5401B","KINGSLEY BRUSHED NICKLE TANK LEVER",null,null,null,31.19,0,{"$f":"H29-I29","v":31.19}]
[1,1,"MIR1714W","17 X 14 WHITE LAVE",null,null,null,55.78,60,{"$f":"H30-I30","v":-4.2199999999999989}]
[1,1,"D551SSD"," 1 HANDLE LAVE FAUCET",null,null,null,228.06,211,{"$f":"H31-I31","v":17.060000000000002}]
[]
[null,null,null,"GUEST BATH"]
[1,1,"K4198-0","WELLWORTH WHITE ELONGATED GPF BOWL",null,null,null,224.85,166,{"$f":"H34-I34","v":58.849999999999994}]
[1,1,"K4468-0","WELLWORTH WHITE GPF TANK"]
[1,1,"PFTSSC200","WHITE ELONGATED PLASTIC SEAT"]
[1,1,"CSIY5401B","KINGSLEY BRUSHED NICKLE TANK LEVER",null,null,null,31.19,0,{"$f":"H37-I37","v":31.19}]
[1,1,"MIR1714W","17 X 14 WHITE LAVE",null,null,null,55.78,60,-4.2199999999999989]
[1,1,"D3551SS","2 HANDLE WIDESPREAD LAVE FAUCET",null,null,null,303.31,211,92.31]
[1,1,"DRI0000PX","MONITOR ROUGH IN VALVE",null,null,null,35.4,45.46,-10.060000000000002]
[1,1,"DT1425SS","1400 SHOWER TRIM",null,null,null,178.47,161,17.47]
[1,1,"MBI32999","BRUSHED NICKLE GRID DRAIN",null,null,null,20.329999999999998,0,20.329999999999998]
[3,3,"DRP10612","THICK TILE MOUNTING KIT",null,null,null,52.29,0,52.29]
[2,2,"MB132935","BRUSHED NICKLE SNAPIN GRID SHOWER DRAIN",null,null,null,41.58,0,41.58]
[1,1,null,"WHITE GARAGE SINK",null,null,null,375,0,375]
[1,1,"ENSC40","40K TANK WATER SOFTENER",null,null,null,631.34,0,631.34]
[1,1,null,"LABOR & INSTALATION FOR SOFTENER",null,null,null,100,0,100]
[1,1,"TK3LP","PROPANE TANKLESS WATER HEATER",null,null,null,1265,0,1265]
[]
[null,null,"TOTALS",null,null,null,null,{"$f":"SUM(H3:H48)","v":7964.89},{"$f":"SUM(I3:I48)","v":4069.92},{"$f":"SUM(J3:J48)","v":3938.97}]

{"sheet":"Help","index":4,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["This spreadsheet is designed to take an invoice for a construction job as an input, and export any changes to a separate sheet.  This will automatically create a change order form.  It also analyzes the changes on a third sheet, allowing the user to calculate how close the new cost is to the original by percentage. For convenience, there are buttons allowing the user to sort the analysis by percentage and  by total price, as well as a button to generate sample data. "]
[]
["To create a change order form , click on the \"Export Changes\" button. To see an analysis of the changes made, click on the \"Analyze Changes\" button and it will generate  another  list of the changes . "]
[]
["The Analyze tab is used to analyze bid estimates and the change order.  The \"Calculate %\" button shows the percentage of actual cost vs. estimate.  Of course, the closer to \"1\", the better.  This is why percentages less than 50% are highlightesd in red and less than 70% are orange."," "]
[]
["The other two buttons are just used to sort the data, by either dollar amount or percentage."]